package foundation;
import java.sql.Connection;
import java.sql.DriverManager;


public class CCDB {
	private static final String oracleDriverName = "oracle.jdbc.driver.OracleDriver";
	private static final String oracleUrlToConnect = "jdbc:oracle:oci8:afcdb/afcdb@AFCDB";
	

	
	public static Connection getConnection() {
	    Connection conn = null;
		try {
			Class.forName(oracleDriverName);
			conn = DriverManager.getConnection(oracleUrlToConnect);
			conn.setAutoCommit(false);			// disable the auto commit
		} catch (Exception ex) {
			System.out.println(ex.getMessage() + "CCDB connect error......");
		}
		return conn;
	}
}
